2012-09-28 - 5093.100 - Enhancement - SA160 Report #CrystalReportDevelopment

ENHANCEMENT

5093.100 - SA160 report

Requirement Summary

---

Need to change the existing source of SA160 report to BW Multiprovider.

Admin Info

---

Purpose	Changing the current data source for SA160 to BW.
Requested By	Mark Harris
Spec Created By	Mallareddy D
Spec Created Date	09/28/2012
Spec QA by	Uday Kumar P
Objects	SA160 Report.
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1. Currently existing SA160 report is built using the Open Order and Sales excel files which are get generated out of Open order and COPA Cube.
2. Need to create a new SA160 report by replacing the existing source files into BW Multiprovider.
3. Grouping need to be maintained for the report as follows: Region > Sales Org > Sales Office > Sales Group > Customer.
4. Need to include the currency conversion for the report which is similar as other SA series reports.
5. Parameters need to be maintained for the report as follows:

• Current Period
• Currency (Which has USD and Sales Org Currency values)
• Product Group (Material Group)

Solution Summary

---

1. Need to create a BEx query on top of suitable multiprovider.
2. Need to be update with the new connection in existing SA160 report.

Test Plan

SNo.	Test Scenario	Expected Results
1.	New SA160 report has to validated with the existing SA160 report.	Values should be identical.
2.	Validate report as per NEC standards checklist	Report should successfully validate.

Solution Details

---

1. Need to create a BEx query on top of suitable multiprovider.
2. Need to be update with the new connection in existing SA160 report on NBP.
3. Need to validate the report against the existing report.

Issues

---

None